--[[
    编码: JX-24-22
    名称: 出库单-回报失败后再次回报
    作者：HAN  
    日期：2025-1-29

    级别：项目
    
    函数： CompletionReturn

    功能:
        -- 和JW-WMS回报失败后，通过该脚本进行再次回报
        -- 条件是 出库单 的回报状态 = 2 失败
        -- 行按钮/页面按钮触发

    更改记录:

--]]
jx_base= require( "jx_base" )
jx_api = require ( "jx_external_api")

function CompletionReturn ( strLuaDEID ) 
    local nRet, strRetInfo
    -- step1  获取当前选中的巨星任务
    local data_json, obj_attrs
    nRet, data_json = m3.GetSysDataJson( strLuaDEID )
    if ( nRet ~=0 ) then lua.Error( strLuaDEID, debug.getinfo(1), data_json ) end  
    -- [{"id":"","attrs":[{"attr":"","value":""},..]},..]
    local nCount = #data_json
    if ( nCount == 0 ) then  return end
    
    local strCondition, strSetAttr
    local outound_order
    local curTime = os.date("%Y-%m-%d %H:%M:%S")
    local refrush = false
    local err_msg = ""
    for n = 1, #data_json do
        strCondition = "S_ID = '"..lua.trim_guid_str( data_json[n].id ).."'"
        nRet, outound_order = m3.GetDataObjByCondition(strLuaDEID, "Outbound_Order", strCondition )
        if ( nRet == 0 ) then
            if ( outound_order.create_method == "JW-WMS" and ( outound_order.cr_state == 2 or outound_order.cr_state == 3 ) ) then
                nRet, strRetInfo = jx_api.JW_WMS_API_subPickDown( strLuaDEID, outound_order.no )
                -- 更新出库单的完工回报属性
                strCondition = "S_NO = '"..outound_order.no.."'"
                if ( nRet == 0 ) then
                    strSetAttr = "N_CR_STATE = 1, S_CR_ERR = '', T_CR = '"..curTime.."'"
                else
                    lua.Debug( strLuaDEID, debug.getinfo(1), "JW-WMS subPickDown 接口错误", strRetInfo )
                    err_msg = "JW-WMS subPickDown 接口错误! --> "..lua.FormatSQLString( strRetInfo )
                    strSetAttr = "N_CR_STATE = 2, S_CR_ERR = '"..err_msg.."', T_CR = '"..curTime.."'"
                    mobox.setInfo(strLuaDEID, "重推失败！错误信息: " .. strRetInfo)
                end
                nRet, strRetInfo = mobox.updateDataAttrByCondition( strLuaDEID, "Outbound_Order", strCondition, strSetAttr )
                if ( nRet ~= 0 ) then  lua.Error( strLuaDEID, debug.getinfo(1), "更新【出库单】完工回报信息失败!"..strRetInfo ) end   
                refrush = true                
            end
        end
    end
    
    if ( refrush == false ) then return end

    local action = {
        {
            action_type = "refresh",
            value = ""
        }
    }
    mobox.setInfo( strLuaDEID, "重推成功！" )  
    nRet, strRetInfo = mobox.setAction(strLuaDEID, lua.table2str( action ))
    if ( nRet ~= 0 ) then lua.Error( strLuaDEID, debug.getinfo(1), "setAction错误: "..strRetInfo) end          
end